Use this database to create certificates and awards. The database then keeps track of all the certificates you have created.
How to use this solution
To create a certificate that will be used only once, enter information into all the fields in the Individual Recipient layout. Then view the finished certificate by clicking the Report button and then choosing the For Individual report.
If you want to create copies of the same basic certificate for many people, you don't need t
o enter all the information for each person. Instead, click the Multiple Recipient button to go to the Multiple Recipient layout. Enter the basic information once, and it will be repeated for each new record.
How to customize this solution
In Layout mode, create new layouts for your own certificates and awards. See the FileMaker Pro documentation for information on using global fields, such as those used in the Multiple Recipient entry form and certificate.
Add buttons for each new c
Day Mod 10B
Day SuffixB
, >= 11
, <=13)
- >= 4
- = 0
"th"
- = 1
"st"
- = 2
"nd"
"rd")))
rd222
Sig Label 2B
Presented ByB
ReasonB
InfoB
Presented By GlobalB
Sig Label 1 GlobalB
Sig Label 2 GlobalB
Reason GlobalB
Cert Type GlobalB
Date of Cert GlobalB
Multiple InstructionsB
Individual InstructionsB
UsageB
"Multiple"
"Individual")
Multiple
Individual2
Month NameB
YearB
Created ByB
Form View - Individual
A List View
For Individual
Information
Report Menu
For Multiple
Form View - Multiple
Form View - IndividualB
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
|)The Vaughn Middle School Drama Department}
Drama Director~ Principal
9For Participation in the Vaughn Middle School Winter Play
Certificate of Completion
08/01/95
Use this layout to create a certificate for multiple recipients--for example--a graduation certificate.
1. Fill out the fields for the first recipient.
2. Create a new record for each of the other recipients. You need enter only the recipient's name on each new record.
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
A List ViewB
Your Own
Buttonz
Your Own
Button{
Record|
Delete
Record}
Record~
Reports
View As
View As
Close
Reason
Presented By
Signature Label 2
Signature Label 1
Presented To
Type of Certificate
K4Enter data for Individual Recipient of a Certificate
Multiple Recipients
Individual Recipient
Click this button to switch to a layout where you can create a certificate for multiple recipients--for example, a graduation certificate.
For IndividualB
DateX
Presented ByY
Presented ToZ
Type of Certificate[
Your Own
Button]
Your Own
Button^
Record_
Delete
Record`
Recorda
Reportsb
View As
Listc
View As
Formd
Closee
Infof/Click to see more information for a Certificate
InformationB
Your Own
Button}
Reports~
View As
View As
Close
BOPresented By <<
ABDD>>
this <<
ABCM>><<
ABCO>> day of <<
ABEH>>, <<
ABEI>>, to:
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO+Information about the Certificates solutionP
Info for this Solution
Your Own
ButtonC
ReportsD
View As
ListE
View As
FormF
CloseG
InfoH
Your Own
ReportI
Your Own
ReportJ
For Multiple RecipientsK
For Individual RecipientL>Click on any of these buttons to preview the respective reportM
Select a report
For MultipleB
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Form View - MultipleB
Your Own
Button
Reports
View As
View As
Close
on <<
ABEB>> to:
presents this
Your Own
Buttonz
Your Own
Button{
Record|
Delete
Record}
Record~
Reports
View As
View As
Close
K2Enter data for Multiple Recipients of Certificates
Type of Certificate
Presented To
Signature Label 1
Signature Label 2
Presented By
Reason
Individual Recipient
Multiple Recipients
Click this button to switch to a layout where you can create a certificate customized for a single person--for example, winner of a spelling bee.
tiple Certificate
Open Script
Sort by Type of Certificate
Sort by Presented To
Preview Individual Certificate
Sort by Date
Preview Multiple Certificate
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Sort by Number of Recipients
Open Script
) =400
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.E)
Go to Form View
Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
F = "Individual"
Individual
Go to Form View
Sort by Number of Recipients
Sort by Type of Certificate
Sort by Presented To
Sort by Date
Preview Individual Certificate
Preview Multiple Certificate
Open Script
Sort by Type of Certificate
Sort by Presented To
Preview Individual Certificate
Sort by Date
Preview Multiple Certificate
(LIST
LISTAECertificate of Award
Certificate of Merit
Certificate of Completion
VDEFA(
(LIST
LISTA
Individual
VDEFA(
Certificate Type ListB
Number of Recipients List
wwwwww
ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
wwwwww
ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
" 234DUfw
2""2334DEVgx
3 4DEUfwx
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
"%UR
UD33D
3 DDUVgw
D EUUfwx
UDDEUUfgw
U Vfgwx
eUVfgww
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
AD@D@
AD@D@
44444
CCCCC 44444 CCCCC
$42"
@@BA@
bRBBP0
UUUUU
JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))C
'!!!!
*00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
UUUUUU
wwwwww
(*)(%,3&
)%+@6)
",30,)%
#*>A6332+$"!
25,878
#&$690*"
!)0,++)(
"%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<H
/2583$%+66/%
%)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
$$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
!$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!L
//6B&
#'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//O
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!P
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%Q
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGS
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
%'0>GFA:378+&&%$$,&
,:CPQ
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
#%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,
*3*)-/0/+&$$!
6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7[
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
&46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
#'21\
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
DDDDDD
iiiimm
B"#B0
B"#B"$
"2#B"#B"#@
2$""#B"#@
"2#B"#@
2$B"#@
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
iiiimm
ffff33
ff33ff
ff3333
33ffff
33ff33
333333
wwwwww
UUUUUU
DDDDDD
""""""
ffff33
ff33ff
ff3333
33ffff
33ff33
333333
wwwwww
UUUUUU
DDDDDD
""""""
=ertificate design in the Report menu.
You can change the Report scripts so that they print the current Found Set. To do so, edit the For Individual and For Many scripts in ScriptMaker
: remove the Pause after the Preview Mode step and insert a Print step. For more information, see the documentation for ScriptMaker.
(.txt)